package com.example.guiguihomemedical.mapper;

import com.example.guiguihomemedical.entity.Serviceitems;
import com.example.guiguihomemedical.entity.ServiceitemsDescription;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ServiceitemsMapper {
    @Select("SELECT * FROM serviceitems")
    List<Serviceitems> findAllServiceitems();
    @Select("SELECT * FROM serviceitems where service_items_id=#{serviceItemsId}")
    Serviceitems findByIdServiceitems(int serviceItemsId);
    @Select("SELECT * FROM serviceitemdescriptionid")
    List<ServiceitemsDescription> findAllServiceitemsDescription();


    @Select("SELECT * FROM serviceitemdescriptionid where idcard=#{Idcard}")
    List<ServiceitemsDescription> findByIdServiceitemsDescription(String Idcard);

    @Select("SELECT * FROM serviceitemsviewdetailed where idcard=#{Idcard} and signingid=#{signingid}")
    List<ServiceitemsDescription> findByIdServiceitemsdetailed(String Idcard,int signingid);
}
